Eremochrysa punctinerviss step is actually optional. I use it to get the cursor out of the way.
Eremochrysa punctinervis
Paste
Perform
Preview
Previous
Reads
Reasoning
Record
Records
Replace
Script
Scripts
Select/play
Unmarking
Eat-A-Bug Software
FileMaker Pro Tips #1
E)How to Mark & Unmark Records With Scripts
Explanation
Here are the scripts that perform the marking & unmarking.
1. Mark Current Records
s how the script reads...
Enter Browse mode
Go To Field [Select/Play,
Mark This Record
Paste Literal [
Replac
Eremochrysa tibialis
Eremochrysa
ExplanationB
Mark All Records
Unmark All Records
ChrysoperlaE
plorabundaF
Unmark Current Records
Mark All Records
Unmark All Records
Find Eremochrysa
he field and paste something into it, then the newly pasted text is appended onto the end of the field
s prior contents. For example, if the
Mark This Field
is set to
and you paste
into it, the reE
sulting field contents will be
NoYes
. Again, select the field
s contents, then paste the new value into it.
Paste Literal [
- Paste the text string
into
Mark This Field
Replace [No Dialog,
Unmarking
Value
Whatever
E)How to Mark & Unmark Records With Scripts
Mark Current Records
Unmark Current Records
Unmark Current Records
NeuropteraC
ChrysopidaeD
ChrysoperlaE
plorabundaF
Mark This RecordB
SpeciesB
Example
Explanation
About Marking Records...Copy
ExampleB
Pro 2.0F!
Pro 2.0I
Main Dictionary
User Dictionary
_g@"n
Eremochrysa tibialis
Chrysoperla comanche
Eremochrysa
t/Play,
Mark This Record
Paste Literal [
Replace [No Dialog, Replace This Record]
Go To Previous Field
Eremochrysa tibialis
Eremochrysa
he scripts that perform the marking & unmarking.
1. Mark Current Records
s how the script reads...
Enter Browse mode
Go To Field [Select/Play,
Mark This Record
Paste Literal [
Replac
aceceplacece
us Field
way to accomplish your task is to print invitations and mailing labels for everyone in your database and discard the ones for the people you want to exclude from the party, but this is wasteful and time consumiF
A better way would be to enter Define Fields mode, create a new text field called
Mark This Record
, set it to automatically enter the value of
whenever a new record is made, enter the values
Comanche
Appendedontents
Current
Cursor
Dialog
Enter
Example
Field
Field's
Here's
Layout
Literal
Marking
Newly
Noyes
Paste
Pasted
Perform
Place
Preview
Previous
Prior
Proper
Reads
Reasoning
Record
Records
Replace
Resulting
Script
Scripts
Select
Select/play
Selecting
Simply
Something
String
Subsequently
Unmarking
Value
Whatever
Go To Previous Field
- Move the cursor out of the
Mark This Record
field and place in into the previous field. This step is actually optional. I use it to get the cursor out of the way.
2. Unmark CurrentB
Records
s how the script reads...
Enter Browse mode
Go To Field [Select/Play,
Mark This Record
Paste Literal [
Replace [No Dialog,
Mark This Record
Go To Previous Field
And here
s the reason
tinervis
Noyes
Optional
Paste
Pasted
Perform
Place
Preview
Previous
Prior
Proper
Reads
Reasoning
Record
Records
Replace
Resulting
Script
Scripts
Select
Select/play
Selecting
Simply
Something
Unmarking
Value
Whatever
Browse
Current
Dialog
Enter
Field
Here's
Layout
Literal
Marking
Paste
Perform
Preview
Previous
Reads
Reasoning
Record
Records
Replace
Script
Scripts
Select/play
Unmarking
Find Chrysoperla
Chrysoperla
Find Chrysoperla & Unmark Them
& Unmark Them
nmark Them
punctinervis
Eremochrysa
Eremochrysa
e woM
. The current records will all contain the word
Go To Previous Field
- Move the cursor out of the
Mark This Record
field and place in into the previous field. This step is actually optional.
Eremochrysa punctinervis
3333ff
333333
Eremochrysa punctinervis
Next, enter browse mode. Browse through every record in the database and set the value of the
Mark This Record
field to
if you want to invite the person,
if you don
t want him/her invited. Then wB
hen you want to print your invitations and labels you can perform a find for all occurences of
in the
Mark This Record
field. Once found, move to your invitation and mailing label layouts and print the
This template provides directions for marking and unmarking records using scripts available in FileMaker Pro version 2.0. After reading the details, go to the example layout (click on the
Show Me
button on tB
his screen) and try out the items in the Scripts menu.
About Marked Records...
For the uninitiated, marking a record is a way to indicate that it belongs to a group whose members often have nothing in common.
select records that you
About EAB...B
into a pre-defined value list, then exit Define Fields.
Enter Layout mode and reposition the
Mark This Record
field to appear near the top of the record (I prefer it near the top, your preference mayH
vary). Click once on the field, pull down Field Format... from the Format menu, specify that the format should be Radio Buttons, and exit the dialog box.
The technique is frequently used to select records that you wish to find or print as a group.
As an example, suppose that you have a database of friends and you
re planning a birthday party. You may want to D
invite certain people and exclude others. You
ve decided to print invitations and mailing labels directly from FileMaker Pro. Unfortunately, you have no way to select just the people you want to invite. One
About Marking and Unmarking Records...
When you finish printing your invitations and labels, you will need a way to unmark all of your records. That allows you to use the marking technique to group recordD
s for other purposes at a later time (like for a halloween party with a different set of friends). You could browse through the database one-by-one and set the value of
Mark This Record
, but that
Eat-A-Bug Software
FileMaker Pro Tips #1
About Eat-A-Bug Software...
Eat-A-Bug Software provides software to address specific needs in the life sciences, primarily for entomology and botany. Current work centers around the development of database templates for use with FileMak
r use with FileMaker Pro.
Chrysoperla plorabunda
Find All
About EAB...
About Marking Records...
Explain The Scripts
See An Example
Chrysoperla
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
About EAB...
ExampleB
Mark This Record
field and place in into the previous fi
Unmarking
Value
Whatever
Eat-A-Bug Software
FileMaker Pro Tips #1
E)How to Mark & Unmark Records With Scripts Unmark Records With Scripts to Mark & Unmark Records With ScriptsptsE
Chrysoperla plorabunda
Here are the scripts that perform the marking & unmarking.
1. Mark Current Records
s how the script reads...
Enter Browse mode
Go To Field [Select/Play,
Mark This Record
Paste Literal [
Replac
e [No Dialog,
Mark This Record
Go To Previous Field
And here
s the reasoning...
Enter Browse mode
- Get into browse mode, not find, layout, or preview
Go To Field [Select/Play,
Mark This Record
- PC
lace the cursor into the proper field and select its contents. By selecting the contents, whatever you subsequently paste into that field will replace the previous contents of the field. If you simply enter t
Whatever
Actually
Again
Appended
About Marking RecordsB
m all (set the value of
Mark This Record
). Note that if all records are currently being browsed (no find has been done), then this will mark all records.
Unmark Current Records.
- For the currentlyH
found set, unmark them all (set the value of
Mark This Record
). Note that if all records are currently being browsed (no find has been done), then this will unmark all records.
Mark All Records.
Unmark
Unmarking
Value
Mark This Record
- Replace the contents of the field
Mark This Record
for the current records with the word
. The current records will all contain the word
its contents. By selecting the contents, whatever you subsequently paste into that field will replace the previous contents of the field. If you simply enter t
I{ Find all records, then mark the current records.
Unmark All Records.
- Find all records, then unmark the current records.
, but that
s time consuming.
Instead, u
Unmarking
Value
ime consuming. Instead, use the enclosed scripts to automate your task. Four scripts are included in this database: Mark Current Records, Unmark Current Records, Mark All Records, and Unmark All Records. An F
detailed explanation of how they work is in the layout entitled,
Explanation
. To get there, you can select
Explanation
from the Scripts menu.
Mark Current Records.
- For the currently found set, mark the
vited.
Then when you want to print your invitations and labels you can perform a find for all occurences of
in the
Mark This Record
field.
rrent.
Perform Script [Sub-scripts,
Mark Current Records
- Execute the script
Mark Current Records.
4. Unmark All Records
s how the script reads...
Find All
Perform Script [Sub-scripts,
Unmark D
Current Records
And here
s the reasoning...
Find All
- Find all the records in the database. This makes all the records current.
Perform Script [Sub-scripts,
Unmark Current Records
- Execute the scE
ript
Unmark Current Records.
ing...
Enter Browse mode
- Get into browse mode, not find, layout, or preview
Go To Field [Select/Play,
Mark This Record
- Place the cursor into the proper field and select its contents. By selecting D
the contents, whatever you subsequently paste into that field will replace the previous contents of the field. If you simply enter the field and paste something into it, then the newly pasted text is appended
onto the end of the field
s prior contents. For example, if the
Mark This Field
is set to
and you paste
into it, the resulting field contents will be
YesNo
. Again, select the field
s contents, F
then paste the new value into it.
Paste Literal [
- Paste the text string
into
Mark This Field
Replace [No Dialog,
Mark This Record
- Replace the contents of the field
Mark This Record
G^r the current records with the word
. The current records will all contain the word
selecting D
the contents, whatever you subsequently paste into that field will replace the previous contents of the field. If you simply enter the field and paste something into it, then the newly pasted text is appended
Go To Previous Field
- Move the cursor out of the
Mark This Record
field and place in into the previous field. This step is actually optional. I use it to get the cursor out of the way.
3. Mark All RecoB
s how the script reads...
Find All
Perform Script [Sub-scripts,
Mark Current Records
And here
s the reasoning...
Find All
- Find all the records in the database. This makes all the records cu
Mark This Record
- Replace the contents of the field
Mark This Record
for the current records with the word
. The current records will all contain the word
Chrysoperla plorabunda
Mark This Record
field and place in into the previous field. This step is actually optional. I use it to get the cursor out of the way.
2. Unmark Currenttually optional. I use it to get the cursor out of the way.
2. Unmark Current
Chrysoperla plorabunda
er Pro. Original work was solely on the Macintosh, but with the release of FileMaker Pro for Windows, our templates are being ported over and released into that market as well.
Our two shipping products are CC
ollection Manager (a template to track arthropod collection/sighting data and print specimen labels & reports) and the Photo Slide Manager (a template to track photographic slides and print adhesive labels, rep
erical Online: N2 Bugs
current records will all contain the word
Chrysoperla plorabunda
orts, & lecture guides).
To purchase these items, contact:
BioQuip Products, Inc.
17803 LaSalle Avenue
Gardena, CA 90248-3602 USA
(310) 324-0620
BioQuip sells specimen collecting and storage equipment, plus E
hoards of books. If you
re a biologist and/or an educator, write or call for a catalog.
I hope that you enjoy the tips in this template. Please distribute this template as widely as possible. As I get the t
ime, I plan to release more such tips -- I wish that others would do the same!
(.txt)